MS Excel Beginners Course
Course ID: 260518 0106 616ESH
Course Dates : 18/05/2026 Course Duration : 5 Studying Day/s Course Location: London, United Kingdom
Language: Bilingual
Course Category: Computer Science Programmes
Course Subcategories:
Advanced Excel & Modelling Data Analysis Data Science Information Systems Programming & Development Systems Architecture
Course Certified By: ESHub CPD & LondonUni - Executive Management Training
* Professional Training and CPD Programs
Certification Will Be Issued:
From London, United Kingdom
Course Fees:
VAT varies by course location and participant nationality.
Date has passed please contact us Sales@e-s-hub.com
Introduction
Microsoft Excel is one of the most widely used applications for organising information, performing calculations, analysing data, and producing professional reports. Whether used in administration, finance, operations, sales, or project management, strong Excel skills improve productivity, reduce manual work, and support better business decisions.
This five-day course introduces the essential features of Microsoft Excel through practical, hands-on exercises. Participants will learn how to create worksheets, enter and format data, use basic formulas and functions, organise information, create charts, and prepare professional spreadsheets that can be used immediately in the workplace.
Objectives
2. Enter, organise, and format data to produce clear and professional spreadsheets.
3. Perform calculations using basic formulas and commonly used Excel functions.
4. Sort, filter, and analyse simple datasets and present information using charts and tables.
5. Prepare, print, and share Excel worksheets suitable for everyday business use.
Who Should Attend
1. Administrative Assistants and Office Staff.
2. Finance, Accounting, and Payroll Assistants.
3. Sales, Customer Service, and Operations Personnel.
4. Supervisors and Team Leaders who prepare routine reports.
5. Anyone with little or no prior experience using Microsoft Excel.
Training Method
• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Post-assessment
If Applicable:
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts
Program Support
This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.
Course Agenda
Daily Schedule (Monday to Friday)
- 09:00 AM – 10:30 AM Technical Session 1
- 10:30 AM – 12:00 PM Technical Session 2
- 12:00 PM – 01:00 PM Technical Session 3
- 01:00 PM – 02:00 PM Lunch Break (If Applicable)
- Participants are expected to engage in guided self-study, reading, or personal reflection on the day’s content. This contributes toward the CPD accreditation and deepens conceptual understanding.
- 02:00 PM – 04:00 PM Self-Study & Reflection
Please Note:
- All training sessions are conducted from Monday to Friday, following the standard working week observed in the United Kingdom and European Union. Saturday and Sunday are official weekends and are not counted as part of the course duration.
- Coffee and refreshments are available on a floating basis throughout the morning. Participants may help themselves at their convenience to ensure an uninterrupted learning experience Provided if applicable and subject to course delivery arrangements.
- Lunch Provided if applicable and subject to course delivery arrangements.
Week 1
Day 1 – Getting Started with Microsoft Excel
1. Introduction to Excel
- Understanding the Excel interface
- Creating and saving workbooks
- Navigating worksheets and cells
2. Working with Data
- Entering and editing data
- Using AutoFill and basic formatting
- Managing rows, columns, and worksheets
3. Workbook Organisation
- Renaming worksheets
- Moving and copying data
- Applying basic page layouts
Day 2 – Formulas and Functions
1. Basic Formulas
- Mathematical calculations
- Cell references
- Formula copying techniques
2. Essential Functions
- SUM, AVERAGE, MIN, and MAX
- COUNT and COUNTA
- Basic IF function
3. Formatting Data
- Number formats
- Cell styles
- Conditional formatting basics
Day 3 – Managing Data
1. Organising Information
- Creating Excel tables
- Sorting records
- Filtering data
2. Data Validation
- Creating drop-down lists
- Preventing invalid entries
- Input messages and error alerts
3. Finding Information
- Using Find and Replace
- Navigating large worksheets
- Managing worksheet views
Day 4 – Charts and Printing
1. Creating Charts
- Column and bar charts
- Line and pie charts
- Selecting appropriate chart types
2. Formatting Charts
- Editing chart elements
- Adding titles and labels
- Improving chart readability
3. Printing Worksheets
- Page setup
- Print areas
- Headers, footers, and scaling
Day 5 – Practical Excel Workshop
1. Spreadsheet Development Exercise
- Creating a business worksheet
- Applying formulas and formatting
- Organising data effectively
2. Reporting Exercise
- Sorting and filtering information
- Creating charts
- Preparing a printable report
3. Implementation Planning
- Applying Excel skills to daily work
- Identifying opportunities for automation
- Course review, feedback and implementation planning



















































